<?php

declare(strict_types=1);

namespace app\model;

use think\facade\Config;
use think\exception\HttpException;
use think\facade\Cache;
use think\facade\Request;

use app\model\Base;

class ArticleEn extends Base
{
    protected $schema = [
        "id"          => "int",
        "cid"         => "int",
        "title"       => "varchar",
        "writer"      => "varchar",
        "source"      => "varchar",
        "pubtime"     => "datetime",
        "titlepic"    => "varchar",
        "keywords"    => "varchar",
        "summary"     => "varchar",
        "content"     => "varchar",
        "discussed"   => "int",
        "status"      => "int",
        "top"         => "int",
        "sort"       => "int",
        "hits"        => "int",
        "likes"       => "int",
        "userid"      => "int",
        "username"    => "varchar",
        "create_time" => "int",
        "update_time" => "int",
        "type"        => "int",
        "level"        => "int"
    ];

    protected $disuse = ['top', 'discussed'];

    public function category()
    {
        return $this->belongsTo('Category', 'cid')->bind(['category_name_en' => 'name_en', 'category_url' => 'url', 'route' => 'route']);
    }

    public static function queryPage($params)
    {
        $where = [];

        if (isset($params['status'])) {
            $where[] = ['status', '=', (int) $params['status']];
        }

        if (isset($params['userid'])) {
            $where[] = ['userid', '=', (int) $params['userid']];
        }

        if (!empty($params['cid'])) {
            $where[] = ['cid', '=', (int) $params['cid']];
        }

        if (!empty($params['key'])) {
            $where[] = ['title|keywords', 'LIKE', '%' . (string)$params['key'] . '%'];
        }

        if (!empty($params['yearMonth'])) {
            if (!preg_match("/^([0-9]{4})\/([0-9]{1,2})$/", $params['yearMonth']) && !preg_match("/^([0-9]{4})-([0-9]{1,2})$/", $params['yearMonth'])) {
                throw new HttpException(404, '日期格式不正确');
            }
            $separator = strrpos($params['yearMonth'], '/') ? '/' : '-';

            $year = $month = '';

            if (strnatcasecmp(PHP_VERSION, '7.0.0') >= 0) {
                list($year, $month) = explode($separator, $params['yearMonth']);
            } else {
                list($month, $year) = explode($separator, $params['yearMonth']);
            }

            if ((int) $month < 1 || (int) $month > 12) {
                throw new HttpException(404, '日期格式不正确');
            }

            $days = month_frist_and_last_day($year, $month);

            // $where['create_time'] = ['between', [$days['firstday'], $days['lastday']]];
            $where[] = ['create_time', 'between', [$days['firstday'], $days['lastday']]];
        }

        $limit = empty($params['limit']) ? Config::get('app.page_size', 15) : (int)$params['limit'];

        $order = ['id desc'];
        if (!empty($params['order'])) {
            if (is_array($params['order'])) {
                $order = array_unique(array_merge($params['order']));
            } else {
                array_push($order, $params['order']);
                $order = array_unique($order);
            }
        }

        $list = self::where($where)
            ->field('id,cid,title,titlepic,username,summary,hits,sort,status,pubtime,create_time')
            ->with(['category'])
            ->order($order)->paginate(['list_rows' => $limit, 'query' => $params]);

        return $list;
    }

    public static function getListByCid($cid = 0, $limit = 10, $order = "")
    {
        $where = [];

        if ($cid != 0) {
            if ($cid < 0) {
                $where[] = ['cid', '<>', abs($cid)];
            } else {
                $where[] = ['cid', '=', $cid];
            }
        }

        $where[] = ['status', '=', 1];

        $order = $order ?? "sort ASC,id DESC";

        return self::with('category')->where($where)
            ->field('id,cid,title,titlepic,username,summary,hits,sort,status,create_time')
            ->order($order)->limit($limit)->select();
    }

    public static function getTop($limit)
    {
        return self::with('category')->field('id,cid,title,titlepic,summary,username,hits,sort,status,create_time')
            ->order('sort ASC, id DESC')->limit($limit)->select();
    }

    public static function getOne($id)
    {
        if (!$id) {
            throw new HttpException(404, 'not found');
        }

        $data = self::with('category')->find($id);

        $data->content = str_replace('oembed>', "video>", str_replace('<oembed url', "<video controls='controls' src", $data->content));

        $ip = Request::ip();
        $time = time();

        $key = $id . '-' . $ip;

        $history = (int) Cache::get($key);

        if (!$history) {
            self::where('id', $id)->inc('hits')->update();
            Cache::set($key, $time);
        } else {
            if ($history < $time - 24 * 3600) {
                self::where('id', $id)->inc('hits')->update();
            }
        }

        return $data;
    }

    public static function getNextPrev($id, $cid = null)
    {
        $whereP = [];
        $whereN = [];

        $whereP[] = ['status', '=', 1];
        $whereN[] = ['status', '=', 1];

        if ($cid) {
            $whereP[] = ['cid', '=', $cid];
            $whereN[] = ['cid', '=', $cid];
        }

        $whereP[] = ['id', "<", $id];
        $whereN[] = ['id', ">", $id];

        $data_P = self::where($whereP)->field('id, title, create_time')->order("id desc")->limit(1)->find();
        $data_N = self::where($whereN)->field('id, title, create_time')->order("id asc")->limit(1)->find();

        return ['prev' => $data_P, 'next' => $data_N];
    }

    public static function createTimeArchive($limit = 0)
    {
        if ($limit == 0) {
            $timeList = self::distinct(true)->fieldRaw("FROM_UNIXTIME(`create_time`, '%Y-%m') as pubmonth")->order('pubmonth desc')->select();
        } else {
            $timeList = self::distinct(true)->fieldRaw("FROM_UNIXTIME(`create_time`, '%Y-%m') as pubmonth")->order('pubmonth desc')->limit($limit)->select();
        }

        return $timeList;
    }
}
